//
//  SqlStatement+UserOperation.m
//  LYYGame
//
//  Created by YUJIABO on 17/3/16.
//  Copyright © 2017年 YUJIABO. All rights reserved.
//

#import "SqlStatement+UserOperation.h"

@implementation SqlStatement (UserOperation)

+ (NSString*)insertUserSql
{
  return @"insert into UserInfoTable(userId, idcarNo,password,platformId,phone,qq,sex,nickname,location,headIcon,regType,forbiddenStartTime,lastLoginTime,loginAccount,emailStatus,headIconSmall,address,loginType,registerIp,lastLoginIp,email,channel,versionCode,forbiddenEndTime,osType,realName,platformName,forbiddenRemark,createTime,age,ip,versionName,phoneStatus,lyb,jf,lyq) values (?, ?,?, ?,?, ?,?, ?,?,?, ?,?, ?,?,?, ?,?, ?,?,?, ?,?, ?,?,?, ?,?, ?,?,?,?,?,?,?,?,?)";
    
}

+ (NSString*)updateUserSql
{
   return @"update  UserInfoTable set idcarNo = ?,password =?,platformId = ?,phone = ?,qq = ?,sex = ?,nickname = ?,location = ?,headIcon = ?,regType = ?,forbiddenStartTime = ?,lastLoginTime = ?,loginAccount = ?,emailStatus = ?,headIconSmall = ?,address = ?,loginType = ?,registerIp = ?,lastLoginIp = ?,email = ?,channel = ?,versionCode = ?,forbiddenEndTime = ?,osType = ?,realName = ?,platformName = ?,forbiddenRemark = ?,createTime = ?,age = ?,ip = ?,versionName = ?,phoneStatus = ?,lyb = ?,jf = ? ,lyq = ? where userId = ?";
}
@end
